*Converting to jan 2000 dollars


*Series Id:����CUURA422SA0,CUUSA422SA0	
*Not Seasonally Adjusted			
*Area:���������San Francisco-Oakland-San Jose, CA			
*Item:���������All items			
*Base Period:��1982-84=100		
* http://data.bls.gov/PDQ/servlet/SurveyOutputServlet	

*generate a variable for month number where jan is 1, feb is 2 etc
gen month = (int(sr_date_transfer/100)-int(sr_date_transfer/10000)*100)

gen cpi=.
replace cpi = 	128.5	if year ==	1990	& (month ==	1)
replace cpi = 	129.2	if year ==	1990	& (month ==	2)
replace cpi = 	130	    if year ==	1990	& (month ==	3)
replace cpi = 	130.7	if year ==	1990	& (month ==	4)
replace cpi = 	130.8	if year ==	1990	& (month ==	5)
replace cpi = 	131.6	if year ==	1990	& (month ==	6)
replace cpi = 	132.3	if year ==	1990	& (month ==	7)
replace cpi = 	133.1	if year ==	1990	& (month ==	8)
replace cpi = 	134	    if year ==	1990	& (month ==	9)
replace cpi = 	134.6	if year ==	1990	& (month ==	10)
replace cpi = 	134.7	if year ==	1990	& (month ==	11)
replace cpi = 	135.1	if year ==	1990	& (month ==	12)
replace cpi = 	136.7	if year ==	1991	& (month ==	1)
replace cpi = 	136.1	if year ==	1991	& (month ==	2)
replace cpi = 	136.3	if year ==	1991	& (month ==	3)
replace cpi = 	135.8	if year ==	1991	& (month ==	4)
replace cpi = 	136.2	if year ==	1991	& (month ==	5)
replace cpi = 	137.6	if year ==	1991	& (month ==	6)
replace cpi = 	138.2	if year ==	1991	& (month ==	7)
replace cpi = 	139.1	if year ==	1991	& (month ==	8)
replace cpi = 	139.7	if year ==	1991	& (month ==	9)
replace cpi = 	139.6	if year ==	1991	& (month ==	10)
replace cpi = 	139.8	if year ==	1991	& (month ==	11)
replace cpi = 	139.8	if year ==	1991	& (month ==	12)
replace cpi = 	140.3	if year ==	1992	& (month ==	1)
replace cpi = 	141  	if year ==	1992	& (month ==	2)
replace cpi = 	141.9	if year ==	1992	& (month ==	3)
replace cpi = 	141.6	if year ==	1992	& (month ==	4)
replace cpi = 	141.9	if year ==	1992	& (month ==	5)
replace cpi = 	141.9	if year ==	1992	& (month ==	6)
replace cpi = 	142.2	if year ==	1992	& (month ==	7)
replace cpi = 	142.7	if year ==	1992	& (month ==	8)
replace cpi = 	143.7	if year ==	1992	& (month ==	9)
replace cpi = 	144.3	if year ==	1992	& (month ==	10)
replace cpi = 	144.2	if year ==	1992	& (month ==	11)
replace cpi = 	144.3	if year ==	1992	& (month ==	12)
replace cpi = 	145.1	if year ==	1993	& (month ==	1)
replace cpi = 	145.5	if year ==	1993	& (month ==	2)
replace cpi = 	145.7	if year ==	1993	& (month ==	3)
replace cpi = 	146.8	if year ==	1993	& (month ==	4)
replace cpi = 	146.9	if year ==	1993	& (month ==	5)
replace cpi = 	146.1	if year ==	1993	& (month ==	6)
replace cpi = 	146.1	if year ==	1993	& (month ==	7)
replace cpi = 	146.2	if year ==	1993	& (month ==	8)
replace cpi = 	146.5	if year ==	1993	& (month ==	9)
replace cpi = 	147	    if year ==	1993	& (month ==	10)
replace cpi = 	147.2	if year ==	1993	& (month ==	11)
replace cpi = 	147	    if year ==	1993	& (month ==	12)
replace cpi = 	147.5	if year ==	1994	& (month ==	1)
replace cpi = 	147.4	if year ==	1994	& (month ==	2)
replace cpi = 	148.2	if year ==	1994	& (month ==	3)
replace cpi = 	148	    if year ==	1994	& (month ==	4)
replace cpi = 	148.3	if year ==	1994	& (month ==	5)
replace cpi = 	148.1	if year ==	1994	& (month ==	6)
replace cpi = 	148.9	if year ==	1994	& (month ==	7)
replace cpi = 	149.4	if year ==	1994	& (month ==	8)
replace cpi = 	149.4	if year ==	1994	& (month ==	9)
replace cpi = 	149.4	if year ==	1994	& (month ==	10)
replace cpi = 	149.8	if year ==	1994	& (month ==	11)
replace cpi = 	149.4	if year ==	1994	& (month ==	12)
replace cpi = 	150.3	if year ==	1995	& (month ==	1)
replace cpi = 	150.5	if year ==	1995	& (month ==	2)
replace cpi = 	151.1	if year ==	1995	& (month ==	3)
replace cpi = 	151.5	if year ==	1995	& (month ==	4)
replace cpi = 	151.3	if year ==	1995	& (month ==	5)
replace cpi = 	151.7	if year ==	1995	& (month ==	6)
replace cpi = 	151.5	if year ==	1995	& (month ==	7)
replace cpi = 	151.5	if year ==	1995	& (month ==	8)
replace cpi = 	152.3	if year ==	1995	& (month ==	9)
replace cpi = 	152.6	if year ==	1995	& (month ==	10)
replace cpi = 	152.4	if year ==	1995	& (month ==	11)
replace cpi = 	152.1	if year ==	1995	& (month ==	12)
replace cpi = 	152.9	if year ==	1996	& (month ==	1)
replace cpi = 	153.2	if year ==	1996	& (month ==	2)
replace cpi = 	152.9	if year ==	1996	& (month ==	3)
replace cpi = 	153.9	if year ==	1996	& (month ==	4)
replace cpi = 	155.1	if year ==	1996	& (month ==	5)
replace cpi = 	155.2	if year ==	1996	& (month ==	6)
replace cpi = 	155.9	if year ==	1996	& (month ==	7)
replace cpi = 	155.6	if year ==	1996	& (month ==	8)
replace cpi = 	156.3	if year ==	1996	& (month ==	9)
replace cpi = 	156.9	if year ==	1996	& (month ==	10)
replace cpi = 	156.9	if year ==	1996	& (month ==	11)
replace cpi = 	156	    if year ==	1996	& (month ==	12)
replace cpi = 	157	    if year ==	1997	& (month ==	1)
replace cpi = 	157.9	if year ==	1997	& (month ==	2)
replace cpi = 	159.2	if year ==	1997	& (month ==	3)
replace cpi = 	159.6	if year ==	1997	& (month ==	4)
replace cpi = 	159.8	if year ==	1997	& (month ==	5)
replace cpi = 	160	    if year ==	1997	& (month ==	6)
replace cpi = 	160.6	if year ==	1997	& (month ==	7)
replace cpi = 	161.2	if year ==	1997	& (month ==	8)
replace cpi = 	161.6	if year ==	1997	& (month ==	9)
replace cpi = 	162.5	if year ==	1997	& (month ==	10)
replace cpi = 	162.6	if year ==	1997	& (month ==	11)
replace cpi = 	162.6	if year ==	1997	& (month ==	12)
replace cpi = 	163.2	if year ==	1998	& (month ==	1 | month ==2)
replace cpi = 	164.6	if year ==	1998	& (month ==	3 | month ==4)
replace cpi = 	165.5	if year ==	1998	& (month ==	5 | month ==6)
replace cpi = 	166.6	if year ==	1998	& (month ==	7 | month ==8)
replace cpi = 	167.2	if year ==	1998	& (month ==	9 | month ==10)
replace cpi = 	167.4	if year ==	1998	& (month ==	11 | month ==12)
replace cpi = 	169.4	if year ==	1999	& (month ==	1 | month ==2)
replace cpi = 	172.2	if year ==	1999	& (month ==	3 | month ==4)
replace cpi = 	171.8	if year ==	1999	& (month ==	5 | month ==6)
replace cpi = 	173.5	if year ==	1999	& (month ==	7 | month ==8)
replace cpi = 	175.2	if year ==	1999	& (month ==	9 | month ==10)
replace cpi = 	174.5	if year ==	1999	& (month ==	11 | month ==12)
replace cpi = 	176.5	if year ==	2000	& (month ==	1 | month ==2)
replace cpi = 	178.7	if year ==	2000	& (month ==	3 | month ==4)
replace cpi = 	179.1	if year ==	2000	& (month ==	5 | month ==6)
replace cpi = 	181.7	if year ==	2000	& (month ==	7 | month ==8)
replace cpi = 	183.4	if year ==	2000	& (month ==	9 | month ==10)
replace cpi = 	184.1	if year ==	2000	& (month ==	11 | month ==12)
replace cpi = 	187.9	if year ==	2001	& (month ==	1 | month ==2)
replace cpi = 	189.1	if year ==	2001	& (month ==	3 | month ==4)
replace cpi = 	190.9	if year ==	2001	& (month ==	5 | month ==6)
replace cpi = 	191	    if year ==	2001	& (month ==	7 | month ==8)
replace cpi = 	191.7	if year ==	2001	& (month ==	9 | month ==10)
replace cpi = 	190.6	if year ==	2001	& (month ==	11 | month ==12)
replace cpi = 	191.3	if year ==	2002	& (month ==	1 | month ==2)
replace cpi = 	193	    if year ==	2002	& (month ==	3 | month ==4)
replace cpi = 	193.2	if year ==	2002	& (month ==	5 | month ==6)
replace cpi = 	193.5	if year ==	2002	& (month ==	7 | month ==8)
replace cpi = 	194.3	if year ==	2002	& (month ==	9 | month ==10)
replace cpi = 	193.2	if year ==	2002	& (month ==	11 | month ==12)
replace cpi = 	197.7	if year ==	2003	& (month ==	1 | month ==2)
replace cpi = 	197.3	if year ==	2003	& (month ==	3 | month ==4)
replace cpi = 	196.3	if year ==	2003	& (month ==	5 | month ==6)
replace cpi = 	196.3	if year ==	2003	& (month ==	7 | month ==8)
replace cpi = 	196.3	if year ==	2003	& (month ==	9 | month ==10)
replace cpi = 	195.3	if year ==	2003	& (month ==	11 | month ==12)
replace cpi = 	198.1	if year ==	2004	& (month ==	1 | month ==2)
replace cpi = 	198.3	if year ==	2004	& (month ==	3 | month ==4)
replace cpi = 	199	    if year ==	2004	& (month ==	5 | month ==6)
replace cpi = 	198.7	if year ==	2004	& (month ==	7 | month ==8)
replace cpi = 	200.3	if year ==	2004	& (month ==	9 | month ==10)
replace cpi = 	199.5	if year ==	2004	& (month ==	11 | month ==12)
replace cpi = 	201.2	if year ==	2005	& (month ==	1 | month ==2)
replace cpi = 	202.5	if year ==	2005	& (month ==	3 | month ==4)
replace cpi = 	201.2	if year ==	2005	& (month ==	5 | month ==6)
replace cpi = 	203	    if year ==	2005	& (month ==	7 | month ==8)
replace cpi = 	205.9	if year ==	2005	& (month ==	9 | month ==10)
replace cpi = 	203.4	if year ==	2005	& (month ==	11 | month ==12)
replace cpi = 	207.1	if year ==	2006	& (month ==	1 | month ==2)
replace cpi = 	208.9	if year ==	2006	& (month ==	3 | month ==4)
replace cpi = 	209.1	if year ==	2006	& (month ==	5 | month ==6)
replace cpi = 	210.7	if year ==	2006	& (month ==	7 | month ==8)
replace cpi = 	211	if year ==	2006	& (month ==	9 | month ==10)
replace cpi = 	210.4	if year ==	2006	& (month ==	11 | month ==12)
replace cpi = 	213.688	if year ==	2007	& (month ==	1 | month ==2)
replace cpi = 	215.842	if year ==	2007	& (month ==	3 | month ==4)
replace cpi = 	216.123	if year ==	2007	& (month ==	5 | month ==6)
replace cpi = 	216.24	if year ==	2007	& (month ==	7 | month ==8)
replace cpi = 	217.949	if year ==	2007	& (month ==	9 | month ==10)
replace cpi = 	218.485	if year ==	2007	& (month ==	11 | month ==12)
replace cpi = 	219.612	if year ==	2008	& (month ==	1 | month ==2)
replace cpi = 	222.074	if year ==	2008	& (month ==	3 | month ==4)
replace cpi = 	225.181	if year ==	2008	& (month ==	5 | month ==6)
replace cpi = 	225.411	if year ==	2008	& (month ==	7 | month ==8)
replace cpi = 	225.824	if year ==	2008	& (month ==	9 | month ==10)
replace cpi = 	218.528	if year ==	2008	& (month ==	11 | month ==12)
replace cpi = 	222.166	if year ==	2009	& (month ==	1 | month ==2)
replace cpi = 	223.854	if year ==	2009	& (month ==	3 | month ==4)
replace cpi = 	225.692	if year ==	2009	& (month ==	5 | month ==6)
replace cpi = 	225.801	if year ==	2009	& (month ==	7 | month ==8)
replace cpi = 	226.051	if year ==	2009	& (month ==	9 | month ==10)
replace cpi = 	224.239	if year ==	2009	& (month ==	11 | month ==12)
replace cpi = 	226.145	if year ==	2010	& (month ==	1 | month ==2)

*get everything in jan 2000 dollars
replace cpi = cpi/176.5
drop month




